SUPPORT / SAMPLES & SAS NOTES
Problem Note 47095: The error "ORA-01795: maximum number of expressions in a list is 1000" might occur when adding a plan member
 |  |  |  |
In SAS® High Performance Markdown Optimization, the following error might be encountered when using the "Find by Attributes" filter to add members to a plan:
com.sas.solutions.di.server.db.api.PersistenceException: java.sql.SQLException:
ORA-01795: maximum number of expressions in a list is 1000
at com.sas.solutions.di.server.mdo.PlanMembershipFacade.getParentProduct(PlanMembershipFacade.java:856)
.......
The error is generated because the number of members exceeds the limit enforced by Oracle.
To work around this error, select a smaller product scope.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3_M2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |